IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[or_MentoringCommunicationSelectByMenteeAndMentor]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE dbo.[or_MentoringCommunicationSelectByMenteeAndMentor]
Go

CREATE  PROCEDURE  dbo.[or_MentoringCommunicationSelectByMenteeAndMentor]  
	@MenteeID int, @MentorID int
AS

SELECT 
MenteeID, 
MentorID, 
Message, 
SenderID,  
CreatedDate MessageDateTime
FROM  Communication
WHERE MenteeID = @MenteeID AND MentorID = @MentorID